package com.koi.web.controller.demo.easyexecl;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @author ･ᴗ･
 * @description [ExcelBO]
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
@ContentRowHeight(15)
@HeadRowHeight(17)
public class ExcelBo {

    /**
     * @description [value属性设置列的名称，index属性设置设置列的序号从 0 开始]
     */
    @ColumnWidth(30)
    @ExcelProperty(value = "编号", index = 0)
    private Integer id;

    @ColumnWidth(30)
    @ExcelProperty("年龄")
    private Integer age;

    @ColumnWidth(30)
    @ExcelProperty("姓名")
    private String name;

    @ColumnWidth(30)
    @ExcelProperty("语文")
    private Integer wen;

    @ColumnWidth(30)
    @ExcelProperty("数学")
    private Integer richard;

    @ColumnWidth(30)
    @ExcelProperty("总分")
    private Integer sum;

    // 无需导出字段使用此注解 @ExcelIgnore

}
